<?php


/**
 * Description of Status
 *
 * @author 耿鸿飞 <15911185633>
 */
class Pm_Status extends Model
{
    //put your code here
    CREATE TABLE `u_pm_contents` (
  `Fid` int(11) NOT NULL AUTO_INCREMENT,
  `Fkey` char(23) NOT NULL DEFAULT '' COMMENT '两个用户id的拼接',
  `Ffrom` int(11) NOT NULL DEFAULT '0' COMMENT '发送者id,0是系统消息',
  `Fto` int(11) NOT NULL DEFAULT '0' COMMENT '接受者id',
  `Fmsg` text NOT NULL COMMENT '消息内容',
  `Ffromdel` enum('Yes','No') NOT NULL DEFAULT 'No' COMMENT '发送者是否已经删除',
  `Fstatus` enum('UnRead','Read','Del') NOT NULL DEFAULT 'UnRead' COMMENT '接受者是否已经删除',
  `Ftime` int(11) NOT NULL DEFAULT '0' COMMENT '发送时间',
  PRIMARY KEY (`Fid`),
  KEY `Ftime` (`Ftime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户消息';

    
    CREATE TABLE `u_pm_status` (
  `Fid` int(11) NOT NULL AUTO_INCREMENT,
  `Fkey` char(23) NOT NULL DEFAULT '',
  `Ffrom` int(11) NOT NULL DEFAULT '0' COMMENT '发送者id',
  `Ftoid` int(11) NOT NULL DEFAULT '0' COMMENT '接受者id',
  `Ftime` int(11) NOT NULL DEFAULT '0' COMMENT '时间',
  `Fmsg` varchar(255) NOT NULL DEFAULT '' COMMENT '消息内容',
  `Fsum` int(11) NOT NULL DEFAULT '0' COMMENT '未读消息数',
  PRIMARY KEY (`Fid`),
  KEY `Fkey` (`Fkey`),
  KEY `Ffrom` (`Ffrom`),
  KEY `Ftime` (`Ftime`),
  KEY `Fsum` (`Fsum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户消息表';

}

?>
